The 640 MEG Shareware Studio 2/The 640 Meg Shareware Studio CD-ROM Volume II (Data Express)(1993).ISO/educate/flashcne.zip/FLASH.XLM

Excel Spreadsheet | 1992-09-03 | 42KB | 510 lines

Sheet:
(0, 1)        Startup
(0, 5)        75
(0, 6)        60
(0, 7)        600
(0, 8)        243
(0, 9)        Flash Card Error
(0, 12)        Open Worksheets
(0, 14)        First open worksheet list
(0, 15)
(0, 16)        Menus
(0, 17)
(0, 18)
(0, 19)
(0, 20)
(1, 4)        5
(1, 5)        2
(1, 6)        4
(1, 9)        Incorrect Response!
(1, 10)
(1, 12)        NWT1.XLS
(1, 14)        NWT1.XLS
(1, 15)
(1, 17)
(2, 1)        flash setup
(2, 3)
(2, 4)        5
(2, 5)        2
(2, 6)        23
(2, 9)        Question was
(2, 14)        NWT1.XLS
(2, 15)
(2, 16)        Flas&h
(2, 17)
(3, 3)
(3, 4)        5
(3, 5)        2
(3, 6)        38
(3, 9)        In Verna's fatfarm buddy missed doing tracksuit up, what is fatfarm
(3, 12)
(3, 14)        NWT4.XLS
(3, 15)
(3, 16)        &Create new database
(3, 17)        create_new_database
(4, 4)        5
(4, 5)        2
(4, 6)        50
(4, 14)        NWT1.XLS
(4, 15)
(4, 17)
(5, 4)        5
(5, 5)        2
(5, 6)        68
(5, 9)        Your response
(5, 15)
(5, 17)
(6, 4)        5
(6, 5)        2
(6, 6)        83
(6, 15)
(6, 17)
(7, 4)        5
(7, 5)        2
(7, 6)        96
(7, 15)
(7, 17)
(8, 4)        5
(8, 5)        2
(8, 6)        118
(8, 9)        Correct response
(8, 15)
(8, 17)
(9, 4)        5
(9, 5)        2
(9, 6)        137
(9, 9)        duplicate fats and dets
(9, 15)
(9, 17)
(10, 4)        5
(10, 5)        2
(10, 6)        150
(10, 15)
(10, 16)
(10, 17)
(11, 1)
(11, 4)        1
(11, 5)        12
(11, 6)        181
(11, 7)        88
(11, 9)        OK
(11, 15)
(11, 16)
(11, 17)
(12, 0)        flash_sheet
(12, 3)
(12, 4)        2
(12, 5)        12
(12, 6)        215
(12, 7)        88
(12, 9)        &Stop test
(12, 15)
(12, 16)
(12, 17)
(13, 0)        NWT1.XLS
(13, 3)
(13, 4)        3
(13, 5)        112
(13, 6)        215
(13, 7)        105
(13, 9)        &Ignore error
(13, 15)
(13, 16)
(13, 17)
(13, 18)
(14, 1)        create flash setup
(14, 2)        sometimes restart here
(14, 3)
(14, 4)        3
(14, 5)        231
(14, 6)        215
(14, 7)        131
(14, 9)        Modify &question
(14, 15)
(14, 16)
(14, 17)
(14, 18)
(15, 0)
(15, 2)
(15, 3)
(15, 4)        3
(15, 5)        373
(15, 6)        215
(15, 7)        125
(15, 9)        Modify &answer
(15, 15)
(15, 16)
(15, 17)
(16, 0)
(16, 2)
(16, 3)
(16, 4)        5
(16, 5)        215
(16, 6)        4
(16, 9)        Database record # 309
(16, 15)
(16, 16)
(16, 17)
(17, 3)
(17, 15)
(17, 16)
(17, 17)
(18, 3)
(18, 15)
(18, 16)
(18, 17)
(19, 15)
(19, 16)
(19, 17)
(20, 2)        reset the flash setup dialog box
(20, 15)
(20, 16)
(20, 17)
(21, 15)
(21, 16)
(21, 17)
(22, 15)
(22, 16)
(22, 17)
(23, 15)
(23, 16)
(23, 17)
(24, 2)        set up to build selection
(24, 5)
(24, 15)
(24, 16)
(24, 17)
(25, 2)        dialog box
(25, 15)
(25, 16)
(25, 17)
(26, 2)        clear the selected categories
(26, 15)
(26, 16)
(26, 17)
(27, 15)
(27, 16)
(27, 17)
(28, 7)        364
(28, 8)        80
(28, 9)        Flash Cards Setup
(28, 10)        5
(29, 4)        1
(29, 5)        265
(29, 6)        12
(29, 7)        88
(29, 9)        OK
(30, 4)        2
(30, 5)        265
(30, 6)        40
(30, 7)        88
(30, 9)        Cancel
(31, 4)        14
(31, 5)        10
(31, 6)        6
(31, 7)        241
(31, 8)        68
(31, 9)        Choose Flash Cards Database
(32, 4)        11
(32, 10)        3
(33, 2)
(33, 4)        12
(33, 9)        Open Existing Database
(34, 2)
(34, 4)        12
(34, 5)
(34, 6)
(34, 7)
(34, 8)
(34, 9)        Create New Database
(35, 2)        set extract range
(35, 4)        12
(35, 9)        NWT1.XLS
(36, 2)        for category selection
(36, 4)        12
(36, 9)        NWT1.XLS
(37, 4)        12
(37, 9)        NWT4.XLS
(38, 4)        12
(39, 4)        12
(40, 4)        12
(41, 1)        sort database and insert sequence numbers
(41, 4)        12
(43, 0)        num_rows
(43, 7)        543
(43, 8)        168
(43, 9)        Flash Card Setup
(43, 10)        3
(44, 4)        1
(44, 5)        443
(44, 6)        6
(44, 7)        88
(44, 9)        OK
(45, 2)        here's the sort
(45, 4)        2
(45, 5)        444
(45, 6)        35
(45, 7)        88
(45, 9)        Cancel
(46, 2)
(46, 4)        21
(46, 5)        10
(46, 6)        30
(46, 7)        412
(46, 8)        108
(46, 9)        numbers_of_questions
(46, 10)        1
(47, 4)        5
(47, 5)        12
(47, 6)        13
(47, 9)        Choose test category
(48, 9)
(49, 2)        here are the numbers
(51, 2)        extract list of category names
(51, 9)
(53, 9)
(53, 12)        1. Fairy Tales (5)
(54, 0)        num categories
(54, 9)
(54, 12)
(55, 9)
(55, 12)
(56, 2)        set up dialog box
(56, 9)
(56, 12)
(57, 0)
(57, 9)
(57, 12)
(58, 0)
(58, 12)
(59, 0)
(59, 9)
(59, 11)
(59, 12)
(60, 9)
(60, 11)
(60, 12)
(61, 9)
(61, 11)
(61, 12)
(62, 2)        numbers of questions
(62, 9)
(62, 11)
(62, 12)
(63, 2)        in each category
(63, 9)
(63, 11)
(63, 12)
(64, 2)        just the names and numbers
(64, 9)
(64, 11)
(64, 12)
(65, 9)
(65, 11)
(65, 12)
(66, 9)
(66, 11)
(66, 12)
(67, 2)        paste them into
(67, 9)
(67, 11)
(67, 12)
(68, 2)        the macro sheet
(68, 9)
(68, 11)
(68, 12)
(69, 9)
(69, 11)
(69, 12)
(70, 9)
(70, 11)
(70, 12)
(71, 1)        Choose new category
(71, 9)
(71, 11)
(71, 12)
(72, 9)
(72, 11)
(72, 12)
(73, 0)        search chars
(73, 9)
(73, 11)
(74, 9)
(74, 11)
(75, 9)
(75, 11)
(76, 9)
(76, 11)
(77, 9)
(77, 11)
(78, 2)        sometimes restart here
(78, 9)
(78, 11)
(79, 9)
(79, 11)
(80, 9)
(80, 11)
(81, 2)        select correct
(81, 11)
(82, 2)        criteria range
(82, 11)
(83, 11)
(84, 11)
(85, 11)
(86, 0)
(86, 1)
(86, 11)
(88, 2)        extract all questions
(89, 2)        in these categories
(91, 2)        extract range is now
(92, 2)        the new database
(94, 2)        clear the list of
(95, 2)        incorrect answers
(98, 1)        flash_nw
(106, 2)        errors
(107, 2)        0
(109, 0)
(110, 0)
(111, 0)
(112, 0)
(113, 0)
(114, 0)
(115, 1)        loop
(116, 0)        num_words
(116, 2)        total_rows
(117, 0)
(117, 2)        47
(118, 0)        last_row_num
(119, 0)
(119, 1)        pick a row number
(120, 0)        row_num
(122, 0)        question
(122, 2)        starting no of rows
(123, 0)        correct
(123, 2)        46
(124, 0)
(124, 1)        ask a question
(125, 0)        answer
(126, 0)        errors
(126, 2)        check answer
(127, 0)        0
(127, 2)        answer "iii" means I know it
(128, 0)        delete word
(128, 1)        if correct, delete word from list
(134, 1)        if incorrect, give right word
(137, 2)        if all strings one line,
(138, 2)        skip the split-phrase routine
(148, 0)        split point question
(158, 0)        split point correct
(167, 0)        split point answer
(176, 1)        show dbox error
(177, 0)        dbox error return
(178, 2)        Stop test button is cancel
(179, 2)        if false, quit test
(190, 0)        end_loop
(198, 2)        make list of errors
(208, 2)        unique numbers of errors
(209, 2)        become the criteria for the restart
(211, 0)        unique errors
(212, 0)        end loop alert
(215, 2)
(216, 2)
(218, 2)        reselect the original
(219, 2)        database
(220, 0)
(220, 2)        and restart
(222, 0)        endit
(223, 2)        error message
(225, 0)        counter
(226, 0)
(227, 0)        words used
(227, 1)        0
(228, 0)
(230, 1)        Get open worksheets
(232, 2)        get open documents
(233, 2)        create list of open ws's
(235, 2)        Clear old work area
(238, 2)        loop through open docs
(239, 2)        looking for "XLS"
(240, 2)        discard flash.xls
(241, 2)        and scores.xls
(242, 0)        end_names_loop
(243, 2)
(244, 2)
(245, 2)
(252, 1)        split phrase
(261, 0)        found space
(268, 1)        special paste
(282, 1)
(285, 1)        next question cell (N)
(294, 1)        definition question (d)
(302, 1)        Next question and answer (n)
(307, 1)        select all but header
(317, 1)        activate, then test
(323, 1)        What is question (w)
(332, 1)        Find value in questions column
(339, 1)        What it provides
(345, 0)
(347, 1)        Composite questions
(355, 1)        modify question
(356, 0)        modify question response
(360, 0)        modify answer response
(362, 1)        modify correct answer
(365, 1)            =STEP()+ECHO(TRUE)
(371, 1)        Update score sheet
(378, 1)        hide current sheet
(382, 1)        Modify database
(385, 2)
(386, 2)
(387, 2)
(388, 2)
(389, 1)
(389, 2)
(390, 2)
(391, 2)
(392, 2)
(393, 2)
(394, 2)
(395, 2)
(396, 2)
(397, 1)
(397, 2)
(401, 1)        End database modifications
(413, 1)        Modify Flash.xlm
(419, 1)        Open the right files
(426, 1)        Show score chart
(432, 1)        General changeable routine
(433, 2)        parm
(434, 2)        06b. Menu utilities - main menu topics
(439, 1)        Concat
(444, 1)
(446, 1)        Choose database
(448, 0)        no open worksheets
(449, 0)        FALSE
(449, 2)
(450, 1)        Prepare dbox_flash_setup
(451, 2)        put 'em in dbox
(457, 1)
(458, 2)        define dbox correctly
(461, 0)        retry
(461, 2)        find what he wants
(467, 1)
(468, 0)        open a file
(470, 1)
(471, 1)        find difference between two lists
(477, 1)
(478, 0)        found diff
(483, 1)        Update text box
(483, 2)
(484, 2)
(485, 2)
(486, 2)
(487, 2)
(488, 2)
(489, 1)
(489, 2)
(490, 1)        Create new database
(490, 2)
(491, 2)
(499, 1)